<!-- This file is intended to be "included" in other format files. It is not complete. See the [FMP-include] tag in files "detail.htm", "formats.htm". --> [FMP-if:Last Name.neq.] <!-- Setting action="FMPro" causes the Web server to direct processing to FMPro. --> <FORM ACTION="FMPro" METHOD="POST"> <!-- The -db field tells FMPro which FileMaker Pro database to use; the name is not case sensitive. This field is required. --> <INPUT TYPE="hidden" NAME="-db" VALUE="Employees.fp3"> <!-- The -lay field tells FMPro which layout in the database to use; the name is not case sensitive. Specifying a layout is optional; if you omit it then FMPro will use layout 0. Because of the restrictions related to summary fields, calculation fields, auto-entered field, etc., using layout 0 isn't recommended. You should create a layout in FileMaker Pro with exactly the fields used in your "Update" form and then specify that layout with the "-lay" parameter. --> <INPUT TYPE="hidden" NAME="-lay" VALUE="Detail"> <!-- A record ID is a unique number assigned by FileMaker Pro to identify a record. The [FMP-currentrecid] tag is replaced by FMPro with the actual FileMaker Pro record ID. --> <INPUT TYPE="hidden" NAME="-recid" VALUE="[FMP-currentrecid]"> <!-- The -format command tells FMPro the name of the template file to use for formatting output. The file name is not case sensitive, and is required. The file must reside within the same folder as FMPro or within a sub-folder of the folder that FMPro is in. You cannot use aliases to format files. --> <INPUT TYPE="hidden" NAME="-format" VALUE="formats.htm"> <!--The rest of the input fields contain the data values to use when updating a record. Everything between the [FMP-record] and [/FMP-record] tags is repeated for every record returned from the database search. For example, placing the [FMP-record] and [/FMP-record] tags outside of the «table» «/table» tags will create a separate table for each hitlist record. [FMP-record] and [/FMP-record] tags are optional if only one record is being displayed. The [field] tag tells FMPro to substitute a field value from the current record. The field name is a required parameter for the [field] tag. Field names are not case sensitive. [Field] tags can also be placed outside of the [FMP-record] [/FMP-record] container to display the field value for the first record in the found set. This is useful when you want to display summary fields, or a global field like a title, or other header information. The [field] tag may also be used in anchor and image tags. There are some examples here and in the file "summary.txt". Please see the file "Character Encoding of Fields" for important information about optional parameters to the [field] command.--> <P><TABLE BORDER=0> [FMP-record] <TR> <TD> <P><FONT SIZE="-1"><B>First Name: </B>(required)</FONT><BR> <INPUT TYPE="text" NAME="first name" VALUE="[FMP-field: First Name]" SIZE=25> </TD> [FMP-if:currentaction.eq.new] [FMP-Else] <TD VALIGN=TOP ROWSPAN=3> <P><FONT SIZE="-1">Picture:</FONT><BR> <IMG SRC="[FMP-image: Photo]" ALT="Not Available" ALIGN=LEFT></P> <P> </TD> [/FMP-If] </TR> <TR> <TD VALIGN=TOP> <P><FONT SIZE="-1"><B>Last Name: </B>(required)</FONT><BR> <INPUT TYPE="text" NAME="last name" VALUE="[FMP-field: last Name]" SIZE=25> </TD> </TR> <TR> <TD> <P><FONT SIZE="-1"><B>Employee number:</B> (required)</FONT><BR> <INPUT TYPE="text" NAME="employee number" VALUE="[FMP-field: employee number]" SIZE=15></P> <P> </TD> </TR> <TR> <TD COLSPAN=2> <P><FONT SIZE="-1">Street:</FONT><BR> <INPUT TYPE="text" NAME="street" VALUE="[FMP-field: street]" SIZE=42> </TD> </TR> <TR> <TD> <P><FONT SIZE="-1">City:</FONT><BR> <INPUT TYPE="text" NAME="city" VALUE="[FMP-field: city]" SIZE=20> </TD> <TD> <P><FONT SIZE="-1">State/Province:</FONT><BR> <INPUT TYPE="text" NAME="state" VALUE="[FMP-field: state]" SIZE=20> </TD> </TR> <TR> <TD> <P><FONT SIZE="-1">Zip or Postal code:</FONT><BR> <INPUT TYPE="text" NAME="postal code" VALUE="[FMP-field: Postal Code]" SIZE=10> </TD> <TD> <P><FONT SIZE="-1">Country:</FONT><BR> <INPUT TYPE="text" NAME="country" VALUE="[FMP-field: country]" SIZE=20> </TD> </TR> <TR> <TD COLSPAN=2> <P> </TD> </TR> <TR> <TD> <P><FONT SIZE="-1">Home phone:</FONT><BR> <INPUT TYPE="text" NAME="home phone" VALUE="[FMP-field: Home phone]" SIZE=20> </TD> <TD> <P><FONT SIZE="-1">Email address</FONT><BR> <INPUT TYPE="text" NAME="email" VALUE="[FMP-field: email]" SIZE=20> </TD> </TR> <TR> <TD COLSPAN=2> <P><FONT SIZE="-1">Web site:</FONT><BR> <INPUT TYPE="text" NAME="home page" VALUE="[FMP-field: home page]" SIZE=42> </TD> </TR> <TR> <TD COLSPAN=2> <P> </TD> </TR> <!-- The [FMP-option: Field Name] tag can be used to format fields that contain value lists as HTML pop-up/pull-down menus. FMPro will substitute HTML in the form: <OPTION>List Value for every value in the value list. Note that a "blank" selection is provided in the pop-up menu so that the user can choose not to specify a value for this field. --> <TR> <TD> <FONT SIZE="-1">Department:</FONT><BR> <SELECT NAME="Department"> <OPTION VALUE="">- No Selection - [FMP-option: Department] </SELECT> </TD> <!-- The [FMP-valuelist: Field Name] tag can be used to format fields that contain value lists as a set of radio buttons or checkboxes. All HTML between the [FMP-valuelist: Field Name] and [/FMP-valuelist] tags is repeated for every value in the value list. The actual list value is substitued for the [FMP-valuelistitem] tag. --> <TD> <BR><P><FONT SIZE="-1">Shift: [FMP-valuelist: Shift] <INPUT TYPE="radio" NAME="Shift" VALUE="[FMP-valuelistitem]" [FMP-valuelistchecked]>[FMP-valuelistitem] [/FMP-valuelist]</FONT> </TD> </TR> <TR> <TD COLSPAN=2> <P> </P> <P><FONT SIZE="-1">Bonus Plan: <P></P> <BLOCKQUOTE> [FMP-valuelist: Bonus Plan] <INPUT TYPE="checkbox" NAME="Bonus Plan" VALUE="[FMP-valuelistitem]" [FMP-valuelistchecked]>[FMP-valuelistitem] <P></P> [/FMP-valuelist] </BLOCKQUOTE></FONT> </TD> </TR> <TR> <TD COLSPAN=2> <P> </TD> </TR> <TR> <TD COLSPAN=2> <P><FONT SIZE="-1">Job description:</FONT><BR> <TEXTAREA NAME="Job description" ROWS=7 COLS=58 WRAP>[FMP-field: job description]</TEXTAREA></P> <P><HR> </TD> </TR> [/FMP-record] </TABLE> <!-- The name of the update button must be "-edit"; value can be anything. --> <INPUT TYPE="Submit" NAME="-edit" VALUE="Update Record"> <!-- The name of the delete button must be "-delete"; value can be anything. --> <INPUT TYPE="Submit" NAME="-delete" VALUE="Delete Record" onClick="return confirm('Really delete this record?')"> <!-- The button named "-dup" will cause a new record to be added that is an exact duplicate of the one being displayed. The name must be "-dup"; the value can be anything. --> <INPUT TYPE="Submit" NAME="-dup" VALUE="Duplicate Record"> <!-- The reset button has no effect on FMPro, it merely clears the current form. Reset does not change field information stored in the FileMaker Pro database. --> <INPUT TYPE="Reset" VALUE="Reset Values"> </FORM> [FMP-else] <P>Sorry, the record you requested cannot be found. Press the back button in your browser and try again</P> [/FMP-if]